home *** CD-ROM | disk | FTP | other *** search
/ mail.altrad.com / 2015.02.mail.altrad.com.tar / mail.altrad.com / TEST / office deutch / ACCESS.NL-NL / ACCLR.CAB / ACCESS_TEMPLATE_FACULTY.ACCDT_1043 / template / database / objects / queryFacultyExtendedAddFurigana.txt < prev    next >
Text File  |  2006-11-12  |  5KB  |  112 lines
  1. ∩╗┐Operation =1
  2. Option =0
  3. Begin InputTables
  4.     Name ="Faculty"
  5. End
  6. Begin OutputColumns
  7.     Alias ="File As"
  8.     Expression ="IIf(IsNull([Last Name Furigana]),IIf(IsNull([First Name Furigana]),[Company Furigana],[First Name Furigana]),IIf(IsNull([First Name Furigana]),[Last Name Furigana],[Last Name Furigana] & \" \" & [First Name Furigana]))"
  9.     Alias ="Contact Name"
  10.     Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \" \" & [First Name]))"
  11.     Expression ="Faculty.*"
  12. End
  13. Begin OrderBy
  14.     Expression ="IIf(IsNull([Last Name Furigana]),IIf(IsNull([First Name Furigana]),[Company Furigana],[First Name Furigana]),IIf(IsNull([First Name Furigana]),[Last Name Furigana],[Last Name Furigana] & \" \" & [First Name Furigana]))"
  15.     Flag =0
  16.     Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \" \" & [First Name]))"
  17.     Flag =0
  18. End
  19. dbBoolean "ReturnsRecords" ="-1"
  20. dbInteger "ODBCTimeout" ="60"
  21. dbByte "RecordsetType" ="0"
  22. dbBoolean "OrderByOn" ="0"
  23. dbByte "Orientation" ="0"
  24. dbByte "DefaultView" ="2"
  25. dbBoolean "FilterOnLoad" ="0"
  26. dbBoolean "OrderByOnLoad" ="-1"
  27. dbBoolean "TotalsRow" ="0"
  28. dbBinary "GUID" = Begin
  29.     0x8bb1892290b04a4d9b904c0f2871c057
  30. End
  31. dbLongBinary "DOL" = Begin
  32.     0x0acc0e5500000000ab6397e9fa59e6489c9a9ef875cb329a000000005253566c ,
  33.     0x570ae340010000004029283446006100630075006c0074007900000000000000 ,
  34.     0xa07813be085ff249aae6fd9e2988b7cd070000008bb1892290b04a4d9b904c0f ,
  35.     0x2871c057460069006c00650020004100730000000000000003f5339da9076d4a ,
  36.     0xae1e33c02b04686a070000008bb1892290b04a4d9b904c0f2871c05743006f00 ,
  37.     0x6e00740061006300740020004e0061006d00650000000000000019c853d3c1ab ,
  38.     0x0249a2ca235a4cff9b3f07000000ab6397e9fa59e6489c9a9ef875cb329a4c00 ,
  39.     0x61007300740020004e0061006d006500000000000000d59333a5d01a7340b33c ,
  40.     0xc1b4956b48ee07000000ab6397e9fa59e6489c9a9ef875cb329a460069007200 ,
  41.     0x7300740020004e0061006d00650000000000000052304034cee838409eddf5a6 ,
  42.     0xcf79599a07000000ab6397e9fa59e6489c9a9ef875cb329a43006f006d007000 ,
  43.     0x61006e007900000000000000000000000000000000000000000000000c000000 ,
  44.     0x040000000000000000000000000000000000 ,
  45.     0x0acc0e5500000000ab6397e9fa59e6489c9a9ef875cb329a000000005253566c ,
  46.     0x570ae340010000004029283446006100630075006c0074007900000000000000 ,
  47.     0xe924a488092fea4f880e7286e68e55300700000032bebf231e669d4b8e12a401 ,
  48.     0x70238d02460069006c006500200041007300000000000000651ebf815577324a ,
  49.     0xb863a59ce8ae1e2e0700000032bebf231e669d4b8e12a40170238d0243006f00 ,
  50.     0x6e00740061006300740020004e0061006d006500000000000000d5fe167bbf34 ,
  51.     0x2d4a88884b9a6810a20207000000ab6397e9fa59e6489c9a9ef875cb329a4c00 ,
  52.     0x61007300740020004e0061006d00650020004600750072006900670061006e00 ,
  53.     0x6100000000000000851dc2b4e5ed044ab2d7454dcd515d8a07000000ab6397e9 ,
  54.     0xfa59e6489c9a9ef875cb329a4600690072007300740020004e0061006d006500 ,
  55.     0x20004600750072006900670061006e0061000000000000004f28d908b799dd42 ,
  56.     0x956bd42602fc420b07000000ab6397e9fa59e6489c9a9ef875cb329a43006f00 ,
  57.     0x6d00700061006e00790020004600750072006900670061006e00610000000000 ,
  58.     0x000019c853d3c1ab0249a2ca235a4cff9b3f07000000ab6397e9fa59e6489c9a ,
  59.     0x9ef875cb329a4c0061007300740020004e0061006d006500000000000000d593 ,
  60.     0x33a5d01a7340b33cc1b4956b48ee07000000ab6397e9fa59e6489c9a9ef875cb ,
  61.     0x329a4600690072007300740020004e0061006d00650000000000000052304034 ,
  62.     0xcee838409eddf5a6cf79599a07000000ab6397e9fa59e6489c9a9ef875cb329a ,
  63.     0x43006f006d00700061006e007900000000000000000000000000000000000000 ,
  64.     0x000000000c000000040000000000000000000000000000000000
  65. End
  66. Begin
  67.     Begin
  68.         dbText "Name" ="Contact Name"
  69.         dbInteger "ColumnWidth" ="1695"
  70.         dbInteger "ColumnOrder" ="1"
  71.         dbBoolean "ColumnHidden" ="0"
  72.         dbMemo "SmartTags" ="\"urn:schemas-microsoft-com:office:smarttags#PersonName\""
  73.         dbLong "AggregateType" ="-1"
  74.         dbBinary "GUID" = Begin
  75.             0x03f5339da9076d4aae1e33c02b04686a
  76.         End
  77.     End
  78.     Begin
  79.         dbText "Name" ="File As"
  80.         dbInteger "ColumnWidth" ="1695"
  81.         dbInteger "ColumnOrder" ="2"
  82.         dbBoolean "ColumnHidden" ="0"
  83.         dbLong "AggregateType" ="-1"
  84.         dbBinary "GUID" = Begin
  85.             0xa07813be085ff249aae6fd9e2988b7cd
  86.         End
  87.     End
  88. End
  89. Begin
  90.     State =0
  91.     Left =0
  92.     Top =0
  93.     Right =799
  94.     Bottom =520
  95.     Left =-1
  96.     Top =-1
  97.     Right =784
  98.     Bottom =268
  99.     Left =0
  100.     Top =0
  101.     ColumnsShown =539
  102.     Begin
  103.         Left =48
  104.         Top =12
  105.         Right =192
  106.         Bottom =156
  107.         Top =0
  108.         Name ="Faculty"
  109.         Name =""
  110.     End
  111. End
  112.